<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Defining a Waterfall widget</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
h1.whs1 { font-size:11pt; }
p.whs2 { font-size:9pt; }
img_whs3 { border:none; width:936px; height:323px; border-style:none; }
ul.whs4 { list-style:disc; }
ol.whs5 { list-style:disc; }
p.whs6 { font-weight:bold; font-size:10pt; }
ol.whs7 { list-style:decimal; }
p.whs8 { font-size:9pt; margin-top:6px; margin-bottom:6px; }
p.whs9 { font-size:9pt; margin-top:6px; margin-bottom:6px; font-weight:bold; }
ul.whs10 { list-style:square; }
p.whs11 { margin-top:6px; margin-bottom:6px; margin-left:120px; }
ul.whs12 { list-style:decimal; }
p.whs13 { margin-top:6px; margin-bottom:6px; margin-left:24px; }
ol.whs14 { list-style:square; }
p.whs15 { font-size:9pt; margin-top:6px; margin-bottom:6px; font-weight:normal; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nProviding Flash-based analysis and interactivity: Widgets\nCreating a Waterfall widget");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1 class="whs1">Creating a Waterfall widget</h1>
<p class="whs2"><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">A Waterfall widget 
 highlights the increments and decrements of the values of metrics over 
 time. Analysts can use the widget to identify the aspects of the business 
 that are contributing to the fluctuations in the values. The widget can 
 also be used to perform What-if analyses.</font></span></p>
<p class="whs2">&nbsp;</p>
<p class="whs2">The widget consists of a group of clustered 
 bars displayed from left to right. The X-axis contains either attribute 
 elements or metrics, depending on where the attributes and metrics are 
 placed on the Grid/Graph in Design Mode or Editable Mode. The Y-axis displays 
 a range of values based on the metrics on the Grid/Graph.</p>
<p class="whs2">&nbsp;</p>
<p class="whs2"><img src="images/defining_waterfall_widget.gif" width="936px" height="323px" border="0" class="img_whs3"></p>
<p class="whs2">&nbsp;</p>
<p class="whs2">In the widget above, metrics are displayed along 
 the X-axis. The first bar represents the amount of sales revenue generated 
 in 2006. The remaining bars in the widget represent the remaining metrics 
 on the X-axis, including the Depreciation and Tax Expense metrics. These 
 bars depict the business factors that diminished revenue and one factor 
 (the Other Gains and Losses metric) that increased revenue. As a group, 
 these bars highlight the contributions of various aspects of the business 
 on total revenue from sales. This final value is represented by the last 
 bar on the right, which represents Net Income for 2006.</p>
<p class="whs2">&nbsp;</p>
<p class="whs2"><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">The increments 
 and decrements in a Waterfall widget can be calculated and displayed in 
 any of the following ways:</font></span></p>
<ul type="disc" class="whs4">
	
<li class=p><p class="whs2">Increments and decrements are 
 calculated and displayed in the widget according to the metrics that are 
 included on the Grid/Graph that contains the widget and the order of those 
 metrics. </p></li>
	<ul type="disc" class="whs4">
		
<li class=p><p class="whs2">It is recommended that you 
 use this method when the metrics are on the rows of the Grid/Graph and 
 the attributes are on the columns of the Grid/Graph. This allows you to 
 place the metrics along the X-axis in a specific order and view the increment 
 and decrement bars in that order. </p></li>
		
<li class=p><p class="whs2">To ensure that the metrics 
 determine how increments and decrements are calculated and displayed, 
 select the <span style="font-weight: bold;"><B>Increments/Decrements Provided</B></span> 
 check box. For instructions on accessing this check box, see 
<a HREF="Formatting_a_Waterfall_widget.htm">Formatting 
 a Waterfall widget</a>. </p></li>
	</ul>
	
<li class=p><p class="whs2">Increments and decrements are 
 automatically determined by the widget when it is displayed in MicroStrategy 
 Web. They are calculated according to the metrics included on the Grid/Graph.</p></li>
	<ol type="disc" class="whs5">
		<ul type="disc" class="whs4">
			
<li class=p><p class="whs2">It is recommended that 
 you use this method when the metrics are placed on the columns of the 
 Grid/Graph and the attributes are placed on the rows of the Grid/Graph. 
 Using this method requires that you have placed metrics on the columns 
 that depict the total value for each unit of time.</p></li>
			
<li class=p><p class="whs2">To ensure that the widget 
 automatically determines the increments and decrements, clear the <span 
 style="font-weight: bold;"><B>Increments/Decrements Provided</B></span> check 
 box. For instructions on accessing this check box, see 
<a href="Formatting_a_Waterfall_widget.htm">Formatting 
 a Waterfall widget</a>. </p></li>
		</ul>
	</ol>
</ul>
<p class="whs6">&nbsp;</p>
<p class="whs6">To create and add a Waterfall 
 widget to a document</p>
<ol type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Open 
 the document in <span style="font-weight: bold;"><B>Design</B></span> or <span 
 style="font-weight: bold;"><B>Editable Mode</B></span>.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">From 
 the <span style="font-weight: bold;"><B>Insert</B></span> menu, point to <span 
 style="font-weight: bold;"><B>Widgets</B></span>, and then select <span style="font-weight: bold;"><B>Waterfall</B></span>.</p></li>
</ol>
<ol start="3" type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Click 
 the location on the document, other than in the Detail section, to place 
 the widget. <span style="font-size: 9pt; margin-top: 6px; margin-bottom: 6px;"><font size=1 style="font-size:9pt;">The 
 Grid/Graph that contains the widget, which is similar to a standard grid 
 container, is displayed. A small icon is displayed at the bottom right 
 of the Grid/Graph, identifying the type of widget that you added to the 
 document.</font></span></p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">If 
 required, resize the widget by clicking and dragging its handles.</p></li>
</ol>
<p class="whs8">&nbsp;</p>
<p class="whs9">Add 
 objects to the Grid/Graph</p>
<ol start="5" type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">From 
 the Dataset Objects panel on the left, select attributes and metrics, 
 and drag them on top of the widget, as described below.</p></li>
	<ul type="disc" class="whs4">
		
<li class=p><p class="whs8">Place 
 at least <span style="font-weight: bold;"><B>one metric</B></span> on the rows 
 or columns. Any number of metrics and attributes can be placed on the 
 rows and columns. </p></li>
		<ul type="square" class="whs10">
			
<li class=p><p class="whs8">If 
 attributes or metrics are placed on the rows, the attribute elements or 
 metrics are displayed on the X-axis of the widget. If the rows contain 
 both attributes and metrics, a combination of those objects is displayed.</p></li>
		</ul>
	</ul>
</ol>
<p class="whs11"><span 
 style="font-weight: bold;"><B>Note</B></span>:If you want the metrics on the 
 Grid/Graph to generate the increment and decrement bars in the widget, 
 place the metrics on the rows.</p>
<ul start="5" type="1" class="whs12">
	<ol type="disc" class="whs5">
		<ul type="square" class="whs10">
			
<li class=p><p class="whs8">If 
 attributes and/or metrics are placed on the columns, attribute elements 
 and metrics are displayed in the legend. If the columns contain both attributes 
 and metrics, a combination of those objects is displayed.</p></li>
		</ul>
	</ol>
</ul>
<p class="whs8">&nbsp;</p>
<p class="whs9">Enable 
 the widget to be displayed</p>
<ol start="6" type="1" class="whs7">
	
<li style="margin-left: -20px;" class=p><p class="whs13">View 
 and test your results in one of two ways: </p></li>
	<ul type="1" class="whs12">
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>Select 
 <span style="font-weight: bold;"><B>Flash Mode</B></span> from the <span style="font-weight: bold;"><B>Home</B></span> 
 menu. </p></li>
		
<li class=p-TopicTextBulleted2><p class=TopicTextBulleted2>If Flash 
 Mode is not available in the Home menu, you must make Flash Mode available 
 in the document. For steps, see 
<a href="Defining_available_display_modes.htm">Defining 
 which display modes are available to users</a>.</p></li>
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>Select 
 <span style="font-weight: bold;"><B>Interactive Mode</B></span> from the <span 
 style="font-weight: bold;"><B>Home</B></span> menu.</p></li>
		
<li class=p-TopicTextBulleted2><p class=TopicTextBulleted2>The 
 widget must be enabled to be displayed in non-Flash mode to be viewable 
 in Interactive Mode. For instructions to allow a widget to be displayed 
 in non-Flash mode, see 
<a href="Widget_non_Flash.htm">Determining how 
 a widget is rendered in non-Flash modes</a>.</p></li>
	</ul>
</ol>
<p class="whs9">Specify 
 if the metrics in the widget should be used to generate the increment 
 and decrement bars</p>
<ol start="7" type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Right-click 
 the widget and select <span style="font-weight: bold;"><B>Properties</B></span>. 
 The Properties dialog box opens.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Do 
 one of the following: </p></li>
</ol>
<ol type="square" class="whs14">
	<ul type="disc" class="whs4">
		
<li class=p><p class="whs8">To 
 ensure that <span style="font-weight: bold;"><B>Increments</B></span> and <span 
 style="font-weight: bold;"><B>Decrements</B></span> bars are displayed in the 
 widget in the same order of the metrics on the Grid/Graph, select the 
 <span style="font-weight: bold;"><B>Increments/Decrements Provided</B></span> 
 check box. </p></li>
		<ul type="square" class="whs10">
			
<li class=p><p class="whs8">It 
 is recommended that you use this method when the metrics are placed on 
 the rows of the Grid/Graph and the attributes are placed on the columns 
 of the Grid/Graph. This allows you to place the metrics along the X-axis 
 in a specific order and display the <span style="font-weight: bold;"><B>Increment</B></span> 
 and <span style="font-weight: bold;"><B>Decrement</B></span> bars in that same 
 order. </p></li>
		</ul>
		
<li class=p><p class="whs8">To 
 ensure that the increments and decrements bars in the widget are generated 
 automatically, clear the <span style="font-weight: bold;"><B>Increments/Decrements 
 Provided</B></span> check box. </p></li>
		<ul type="square" class="whs10">
			
<li class=p><p class="whs8">It 
 is recommended that you use this method when the metrics are placed on 
 the columns of the Grid/Graph and the attributes are placed on the rows 
 of the Grid/Graph.</p></li>
		</ul>
	</ul>
</ol>
<ol start="9" type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Use 
 the <span style="font-weight: bold;"><B>Text For Last Entry</B></span> field 
 to specify a name or label for the bar on the far right of the widget. 
 For example, you can create a label for the bar called Final Value or 
 End of 2008.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Click 
 <span style="font-weight: bold;"><B>OK</B></span>.</p></li>
</ol>
<p class="whs9">&nbsp;</p>
<p class="whs9">Related 
 topics</p>
<ul type="disc" class="whs4">
	
<li class=p><p class="whs15">
<a 
 href="Formatting_a_Waterfall_widget.htm">Formatting a Waterfall widget</a></p></li>
	
<li class=p><p class="whs15">
<a 
 href="Analyzing_data_in_a_Waterfall_widget.htm">Analyzing data in a Waterfall 
 widget</a></p></li>
	
<li class=p><p class="whs15">
<a 
 href="Using_a_Waterfall_widget_as_a_selector.htm">About using a Waterfall 
 widget as a selector</a></p></li>
	
<li class=p><p class="whs15">
<a 
 href="Flash_Mode.htm">Working with documents in Flash Mode</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
